Dataset statistics
| Number of variables | 27 |
|---|---|
| Number of observations | 112647 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 130.3 MiB |
| Average record size in memory | 1.2 KiB |
Variable types
| Numeric | 9 |
|---|---|
| Categorical | 17 |
| DateTime | 1 |
order_id has a high cardinality: 98665 distinct values | High cardinality |
product_id has a high cardinality: 32951 distinct values | High cardinality |
seller_id has a high cardinality: 3095 distinct values | High cardinality |
seller_city has a high cardinality: 611 distinct values | High cardinality |
product_category_name_english has a high cardinality: 72 distinct values | High cardinality |
customer_id has a high cardinality: 98665 distinct values | High cardinality |
order_delivery_date has a high cardinality: 96049 distinct values | High cardinality |
order_estimated_delivery_date has a high cardinality: 449 distinct values | High cardinality |
payment_type has a high cardinality: 74 distinct values | High cardinality |
customer_unique_id has a high cardinality: 95419 distinct values | High cardinality |
customer_city has a high cardinality: 4110 distinct values | High cardinality |
order_year is highly correlated with order_month | High correlation |
order_month is highly correlated with order_year | High correlation |
order_year is highly correlated with order_month | High correlation |
order_month is highly correlated with order_year | High correlation |
seller_zip_code is highly correlated with seller_state and 1 other fields | High correlation |
seller_state is highly correlated with seller_zip_code and 1 other fields | High correlation |
product_category_name_english is highly correlated with seller_zip_code and 1 other fields | High correlation |
customer_zip_code is highly correlated with customer_state | High correlation |
customer_state is highly correlated with customer_zip_code | High correlation |
order_year is highly correlated with order_month | High correlation |
order_month is highly correlated with order_year | High correlation |
df_index is uniformly distributed | Uniform |
order_id is uniformly distributed | Uniform |
customer_id is uniformly distributed | Uniform |
order_delivery_date is uniformly distributed | Uniform |
customer_unique_id is uniformly distributed | Uniform |
df_index has unique values | Unique |
Reproduction
| Analysis started | 2021-12-17 18:52:44.305805 |
|---|---|
| Analysis finished | 2021-12-17 18:53:30.110107 |
| Duration | 45.8 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
| Distinct | 112647 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 56323.75256 |
| Minimum | 0 |
|---|---|
| Maximum | 112649 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 880.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5632.3 |
| Q1 | 28161.5 |
| median | 56323 |
| Q3 | 84487.5 |
| 95-th percentile | 107016.7 |
| Maximum | 112649 |
| Range | 112649 |
| Interquartile range (IQR) | 56326 |
Descriptive statistics
| Standard deviation | 32519.50873 |
|---|---|
| Coefficient of variation (CV) | 0.5773675804 |
| Kurtosis | -1.199991297 |
| Mean | 56323.75256 |
| Median Absolute Deviation (MAD) | 28163 |
| Skewness | 5.183415282 × 10-5 |
| Sum | 6344701755 |
| Variance | 1057518448 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 75094 | 1 | < 0.1% |
| 75105 | 1 | < 0.1% |
| 75104 | 1 | < 0.1% |
| 75103 | 1 | < 0.1% |
| 75102 | 1 | < 0.1% |
| 75101 | 1 | < 0.1% |
| 75100 | 1 | < 0.1% |
| 75099 | 1 | < 0.1% |
| 75098 | 1 | < 0.1% |
| Other values (112637) | 112637 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 112649 | 1 | |
| 112648 | 1 | |
| 112647 | 1 | |
| 112646 | 1 | |
| 112645 | 1 | |
| 112644 | 1 | |
| 112643 | 1 | |
| 112642 | 1 | |
| 112641 | 1 | |
| 112640 | 1 |
| Distinct | 98665 |
|---|---|
| Distinct (%) | 87.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.6 MiB |
| 8272b63d03f5f79c56e9e4120aec44ef | 21 |
|---|---|
| ab14fdcfbe524636d65ee38360e22ce8 | 20 |
| 1b15974a0141d54e36626dca3fdc731a | 20 |
| 9ef13efd6949e4573a18964dd1bbe7f5 | 15 |
| 428a2f660dc84138d969ccd69a0ab6d5 | 15 |
| Other values (98660) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 88863 ? |
|---|---|
| Unique (%) | 78.9% |
Sample
| 1st row | 00010242fe8c5a6d1ba2dd792cb16214 |
|---|---|
| 2nd row | 00018f77f2f0320c557190d7a144bdd3 |
| 3rd row | 000229ec398224ef6ca0657da4fc703e |
| 4th row | 00024acbcdf0a6daa1e931b038114c75 |
| 5th row | 00042b26cf59d7ce69dfabb4e55b4fd9 |
Common Values
| Value | Count | Frequency (%) |
| 8272b63d03f5f79c56e9e4120aec44ef | 21 | < 0.1% |
| ab14fdcfbe524636d65ee38360e22ce8 | 20 | < 0.1% |
| 1b15974a0141d54e36626dca3fdc731a | 20 | < 0.1% |
| 9ef13efd6949e4573a18964dd1bbe7f5 | 15 | < 0.1% |
| 428a2f660dc84138d969ccd69a0ab6d5 | 15 | < 0.1% |
| 73c8ab38f07dc94389065f7eba4f297a | 14 | < 0.1% |
| 9bdc4d4c71aa1de4606060929dee888c | 14 | < 0.1% |
| 37ee401157a3a0b28c9c6d0ed8c3b24b | 13 | < 0.1% |
| c05d6a79e55da72ca780ce90364abed9 | 12 | < 0.1% |
| 3a213fcdfe7d98be74ea0dc05a8b31ae | 12 | < 0.1% |
| Other values (98655) | 112491 |
Length
| Value | Count | Frequency (%) |
| 8272b63d03f5f79c56e9e4120aec44ef | 21 | < 0.1% |
| 1b15974a0141d54e36626dca3fdc731a | 20 | < 0.1% |
| ab14fdcfbe524636d65ee38360e22ce8 | 20 | < 0.1% |
| 9ef13efd6949e4573a18964dd1bbe7f5 | 15 | < 0.1% |
| 428a2f660dc84138d969ccd69a0ab6d5 | 15 | < 0.1% |
| 73c8ab38f07dc94389065f7eba4f297a | 14 | < 0.1% |
| 9bdc4d4c71aa1de4606060929dee888c | 14 | < 0.1% |
| 37ee401157a3a0b28c9c6d0ed8c3b24b | 13 | < 0.1% |
| 2c2a19b5703863c908512d135aa6accc | 12 | < 0.1% |
| af822dacd6f5cff7376413c03a388bb7 | 12 | < 0.1% |
| Other values (98655) | 112491 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
order_item_id
Real number (ℝ≥0)
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.197812636 |
| Minimum | 1 |
|---|---|
| Maximum | 21 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 880.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 21 |
| Range | 20 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.7051086788 |
|---|---|
| Coefficient of variation (CV) | 0.5886635837 |
| Kurtosis | 103.8700387 |
| Mean | 1.197812636 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.580982582 |
| Sum | 134930 |
| Variance | 0.497178249 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 98665 | |
| 2 | 9802 | 8.7% |
| 3 | 2286 | 2.0% |
| 4 | 965 | 0.9% |
| 5 | 460 | 0.4% |
| 6 | 256 | 0.2% |
| 7 | 58 | 0.1% |
| 8 | 36 | < 0.1% |
| 9 | 28 | < 0.1% |
| 10 | 25 | < 0.1% |
| Other values (11) | 66 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 98665 | |
| 2 | 9802 | 8.7% |
| 3 | 2286 | 2.0% |
| 4 | 965 | 0.9% |
| 5 | 460 | 0.4% |
| 6 | 256 | 0.2% |
| 7 | 58 | 0.1% |
| 8 | 36 | < 0.1% |
| 9 | 28 | < 0.1% |
| 10 | 25 | < 0.1% |
| Value | Count | Frequency (%) |
| 21 | 1 | < 0.1% |
| 20 | 3 | < 0.1% |
| 19 | 3 | < 0.1% |
| 18 | 3 | < 0.1% |
| 17 | 3 | < 0.1% |
| 16 | 3 | < 0.1% |
| 15 | 5 | < 0.1% |
| 14 | 7 | |
| 13 | 8 | |
| 12 | 13 |
| Distinct | 32951 |
|---|---|
| Distinct (%) | 29.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.6 MiB |
| aca2eb7d00ea1a7b8ebd4e68314663af | 527 |
|---|---|
| 99a4788cb24856965c36a24e339b6058 | 488 |
| 422879e10f46682990de24d770e7f83d | 484 |
| 389d119b48cf3043d311335e499d9c6b | 392 |
| 368c6c730842d78016ad823897a372db | 388 |
| Other values (32946) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 18118 ? |
|---|---|
| Unique (%) | 16.1% |
Sample
| 1st row | 4244733e06e7ecb4970a6e2683c13e61 |
|---|---|
| 2nd row | e5f2d52b802189ee658865ca93d83a8f |
| 3rd row | c777355d18b72b67abbeef9df44fd0fd |
| 4th row | 7634da152a4610f1595efa32f14722fc |
| 5th row | ac6c3623068f30de03045865e4e10089 |
Common Values
| Value | Count | Frequency (%) |
| aca2eb7d00ea1a7b8ebd4e68314663af | 527 | 0.5% |
| 99a4788cb24856965c36a24e339b6058 | 488 | 0.4% |
| 422879e10f46682990de24d770e7f83d | 484 | 0.4% |
| 389d119b48cf3043d311335e499d9c6b | 392 | 0.3% |
| 368c6c730842d78016ad823897a372db | 388 | 0.3% |
| 53759a2ecddad2bb87a079a1f1519f73 | 373 | 0.3% |
| d1c427060a0f73f6b889a5c7c61f2ac4 | 343 | 0.3% |
| 53b36df67ebb7c41585e8d54d6772e08 | 323 | 0.3% |
| 154e7e31ebfa092203795c972e5804a6 | 281 | 0.2% |
| 3dd2a17168ec895c781a9191c1e95ad7 | 274 | 0.2% |
| Other values (32941) | 108774 |
Length
| Value | Count | Frequency (%) |
| aca2eb7d00ea1a7b8ebd4e68314663af | 527 | 0.5% |
| 99a4788cb24856965c36a24e339b6058 | 488 | 0.4% |
| 422879e10f46682990de24d770e7f83d | 484 | 0.4% |
| 389d119b48cf3043d311335e499d9c6b | 392 | 0.3% |
| 368c6c730842d78016ad823897a372db | 388 | 0.3% |
| 53759a2ecddad2bb87a079a1f1519f73 | 373 | 0.3% |
| d1c427060a0f73f6b889a5c7c61f2ac4 | 343 | 0.3% |
| 53b36df67ebb7c41585e8d54d6772e08 | 323 | 0.3% |
| 154e7e31ebfa092203795c972e5804a6 | 281 | 0.2% |
| 3dd2a17168ec895c781a9191c1e95ad7 | 274 | 0.2% |
| Other values (32941) | 108774 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 3095 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.6 MiB |
| 6560211a19b47992c3666cc44a7e94c0 | 2033 |
|---|---|
| 4a3ca9315b744ce9f8e9374361493884 | 1987 |
| 1f50f920176fa81dab994f9023523100 | 1931 |
| cc419e0650a3c5ba77189a1882b7556a | 1775 |
| da8622b14eb17ae2831f4ac5b9dab84a | 1551 |
| Other values (3090) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 509 ? |
|---|---|
| Unique (%) | 0.5% |
Sample
| 1st row | 48436dade18ac8b2bce089ec2a041202 |
|---|---|
| 2nd row | dd7ddc04e1b6c2c614352b383efe2d36 |
| 3rd row | 5b51032eddd242adc84c38acab88f23d |
| 4th row | 9d7a1d34a5052409006425275ba1c2b4 |
| 5th row | df560393f3a51e74553ab94004ba5c87 |
Common Values
| Value | Count | Frequency (%) |
| 6560211a19b47992c3666cc44a7e94c0 | 2033 | 1.8% |
| 4a3ca9315b744ce9f8e9374361493884 | 1987 | 1.8% |
| 1f50f920176fa81dab994f9023523100 | 1931 | 1.7% |
| cc419e0650a3c5ba77189a1882b7556a | 1775 | 1.6% |
| da8622b14eb17ae2831f4ac5b9dab84a | 1551 | 1.4% |
| 955fee9216a65b617aa5c0531780ce60 | 1499 | 1.3% |
| 1025f0e2d44d7041d6cf58b6550e0bfa | 1428 | 1.3% |
| 7c67e1448b00f6e969d365cea6b010ab | 1364 | 1.2% |
| ea8482cd71df3c1969d7b9473ff13abc | 1203 | 1.1% |
| 7a67c85e85bb2ce8582c35f2203ad736 | 1171 | 1.0% |
| Other values (3085) | 96705 |
Length
| Value | Count | Frequency (%) |
| 6560211a19b47992c3666cc44a7e94c0 | 2033 | 1.8% |
| 4a3ca9315b744ce9f8e9374361493884 | 1987 | 1.8% |
| 1f50f920176fa81dab994f9023523100 | 1931 | 1.7% |
| cc419e0650a3c5ba77189a1882b7556a | 1775 | 1.6% |
| da8622b14eb17ae2831f4ac5b9dab84a | 1551 | 1.4% |
| 955fee9216a65b617aa5c0531780ce60 | 1499 | 1.3% |
| 1025f0e2d44d7041d6cf58b6550e0bfa | 1428 | 1.3% |
| 7c67e1448b00f6e969d365cea6b010ab | 1364 | 1.2% |
| ea8482cd71df3c1969d7b9473ff13abc | 1203 | 1.1% |
| 7a67c85e85bb2ce8582c35f2203ad736 | 1171 | 1.0% |
| Other values (3085) | 96705 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 2246 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24437.64254 |
| Minimum | 1001 |
|---|---|
| Maximum | 99730 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 880.2 KiB |
Quantile statistics
| Minimum | 1001 |
|---|---|
| 5-th percentile | 2969 |
| Q1 | 6429 |
| median | 13568 |
| Q3 | 27930 |
| 95-th percentile | 88330 |
| Maximum | 99730 |
| Range | 98729 |
| Interquartile range (IQR) | 21501 |
Descriptive statistics
| Standard deviation | 27594.81009 |
|---|---|
| Coefficient of variation (CV) | 1.129192803 |
| Kurtosis | 0.9332621576 |
| Mean | 24437.64254 |
| Median Absolute Deviation (MAD) | 8038 |
| Skewness | 1.555585514 |
| Sum | 2752827119 |
| Variance | 761473543.8 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14940 | 7750 | 6.9% |
| 5849 | 2047 | 1.8% |
| 15025 | 2008 | 1.8% |
| 9015 | 1781 | 1.6% |
| 13405 | 1567 | 1.4% |
| 4782 | 1518 | 1.3% |
| 8577 | 1456 | 1.3% |
| 3204 | 1428 | 1.3% |
| 4160 | 1229 | 1.1% |
| 13232 | 1195 | 1.1% |
| Other values (2236) | 90668 |
| Value | Count | Frequency (%) |
| 1001 | 19 | < 0.1% |
| 1021 | 39 | < 0.1% |
| 1022 | 5 | < 0.1% |
| 1023 | 5 | < 0.1% |
| 1026 | 303 | |
| 1031 | 124 | |
| 1035 | 17 | < 0.1% |
| 1039 | 1 | < 0.1% |
| 1040 | 24 | < 0.1% |
| 1041 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 99730 | 12 | < 0.1% |
| 99700 | 2 | < 0.1% |
| 99670 | 1 | < 0.1% |
| 99500 | 57 | |
| 99300 | 2 | < 0.1% |
| 98975 | 21 | < 0.1% |
| 98920 | 2 | < 0.1% |
| 98910 | 13 | < 0.1% |
| 98803 | 62 | |
| 98780 | 4 | < 0.1% |
| Distinct | 611 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.2 MiB |
| sao paulo | |
|---|---|
| ibitinga | |
| curitiba | 3013 |
| santo andre | 2964 |
| belo horizonte | 2593 |
| Other values (606) |
Length
| Max length | 40 |
|---|---|
| Median length | 9 |
| Mean length | 10.10200893 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 68 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | volta redonda |
|---|---|
| 2nd row | sao paulo |
| 3rd row | borda da mata |
| 4th row | franca |
| 5th row | loanda |
Common Values
| Value | Count | Frequency (%) |
| sao paulo | 27983 | |
| ibitinga | 7750 | 6.9% |
| curitiba | 3013 | 2.7% |
| santo andre | 2964 | 2.6% |
| belo horizonte | 2593 | 2.3% |
| sao jose do rio preto | 2579 | 2.3% |
| rio de janeiro | 2442 | 2.2% |
| guarulhos | 2362 | 2.1% |
| ribeirao preto | 2269 | 2.0% |
| maringa | 2220 | 2.0% |
| Other values (601) | 56472 |
Length
| Value | Count | Frequency (%) |
| sao | 34728 | 17.9% |
| paulo | 28233 | 14.6% |
| ibitinga | 7750 | 4.0% |
| rio | 5702 | 2.9% |
| do | 5291 | 2.7% |
| preto | 5287 | 2.7% |
| de | 4020 | 2.1% |
| jose | 3904 | 2.0% |
| santo | 3081 | 1.6% |
| curitiba | 3013 | 1.6% |
| Other values (640) | 92660 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 23 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.3 MiB |
| SP | |
|---|---|
| MG | |
| PR | |
| RJ | 4818 |
| SC | 4075 |
| Other values (18) | 5917 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | SP |
|---|---|
| 2nd row | SP |
| 3rd row | MG |
| 4th row | SP |
| 5th row | PR |
Common Values
| Value | Count | Frequency (%) |
| SP | 80342 | |
| MG | 8827 | 7.8% |
| PR | 8668 | 7.7% |
| RJ | 4818 | 4.3% |
| SC | 4075 | 3.6% |
| RS | 2199 | 2.0% |
| DF | 899 | 0.8% |
| BA | 643 | 0.6% |
| GO | 520 | 0.5% |
| PE | 448 | 0.4% |
| Other values (13) | 1208 | 1.1% |
Length
| Value | Count | Frequency (%) |
| sp | 80342 | |
| mg | 8827 | 7.8% |
| pr | 8668 | 7.7% |
| rj | 4818 | 4.3% |
| sc | 4075 | 3.6% |
| rs | 2199 | 2.0% |
| df | 899 | 0.8% |
| ba | 643 | 0.6% |
| go | 520 | 0.5% |
| pe | 448 | 0.4% |
| Other values (13) | 1208 | 1.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 72 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.5 MiB |
| bed_bath_table | |
|---|---|
| health_beauty | |
| sports_leisure | |
| furniture_decor | |
| computers_accessories | |
| Other values (67) |
Length
| Max length | 39 |
|---|---|
| Median length | 13 |
| Mean length | 12.94820989 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | cool_stuff |
|---|---|
| 2nd row | pet_shop |
| 3rd row | furniture_decor |
| 4th row | perfumery |
| 5th row | garden_tools |
Common Values
| Value | Count | Frequency (%) |
| bed_bath_table | 11115 | 9.9% |
| health_beauty | 9667 | 8.6% |
| sports_leisure | 8641 | 7.7% |
| furniture_decor | 8334 | 7.4% |
| computers_accessories | 7827 | 6.9% |
| housewares | 6964 | 6.2% |
| watches_gifts | 5991 | 5.3% |
| telephony | 4545 | 4.0% |
| garden_tools | 4347 | 3.9% |
| auto | 4235 | 3.8% |
| Other values (62) | 40981 |
Length
| Value | Count | Frequency (%) |
| bed_bath_table | 11115 | 9.7% |
| health_beauty | 9667 | 8.5% |
| sports_leisure | 8641 | 7.6% |
| furniture_decor | 8334 | 7.3% |
| computers_accessories | 7827 | 6.8% |
| housewares | 6964 | 6.1% |
| watches_gifts | 5991 | 5.2% |
| telephony | 4545 | 4.0% |
| garden_tools | 4347 | 3.8% |
| auto | 4235 | 3.7% |
| Other values (63) | 42608 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 98665 |
|---|---|
| Distinct (%) | 87.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.6 MiB |
| fc3d1daec319d62d49bfb5e1f83123e9 | 21 |
|---|---|
| bd5d39761aa56689a265d95d8d32b8be | 20 |
| be1b70680b9f9694d8c70f41fa3dc92b | 20 |
| adb32467ecc74b53576d9d13a5a55891 | 15 |
| 10de381f8a8d23fff822753305f71cae | 15 |
| Other values (98660) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 88863 ? |
|---|---|
| Unique (%) | 78.9% |
Sample
| 1st row | 3ce436f183e68e07877b285a838db11a |
|---|---|
| 2nd row | f6dd3ec061db4e3987629fe6b26e5cce |
| 3rd row | 6489ae5e4333f3693df5ad4372dab6d3 |
| 4th row | d4eb9395c8c0431ee92fce09860c5a06 |
| 5th row | 58dbd0b2d70206bf40e62cd34e84d795 |
Common Values
| Value | Count | Frequency (%) |
| fc3d1daec319d62d49bfb5e1f83123e9 | 21 | < 0.1% |
| bd5d39761aa56689a265d95d8d32b8be | 20 | < 0.1% |
| be1b70680b9f9694d8c70f41fa3dc92b | 20 | < 0.1% |
| adb32467ecc74b53576d9d13a5a55891 | 15 | < 0.1% |
| 10de381f8a8d23fff822753305f71cae | 15 | < 0.1% |
| d5f2b3f597c7ccafbb5cac0bcc3d6024 | 14 | < 0.1% |
| a7693fba2ff9583c78751f2b66ecab9d | 14 | < 0.1% |
| 7d321bd4e8ba1caf74c4c1aabd9ae524 | 13 | < 0.1% |
| 3b54b5978e9ace64a63f90d176ffb158 | 12 | < 0.1% |
| 91f92cfee46b79581b05aa974dd57ce5 | 12 | < 0.1% |
| Other values (98655) | 112491 |
Length
| Value | Count | Frequency (%) |
| fc3d1daec319d62d49bfb5e1f83123e9 | 21 | < 0.1% |
| be1b70680b9f9694d8c70f41fa3dc92b | 20 | < 0.1% |
| bd5d39761aa56689a265d95d8d32b8be | 20 | < 0.1% |
| adb32467ecc74b53576d9d13a5a55891 | 15 | < 0.1% |
| 10de381f8a8d23fff822753305f71cae | 15 | < 0.1% |
| d5f2b3f597c7ccafbb5cac0bcc3d6024 | 14 | < 0.1% |
| a7693fba2ff9583c78751f2b66ecab9d | 14 | < 0.1% |
| 7d321bd4e8ba1caf74c4c1aabd9ae524 | 13 | < 0.1% |
| 0d93f21f3e8543a9d0d8ece01561f5b2 | 12 | < 0.1% |
| 9eb3d566e87289dcb0acf28e1407c839 | 12 | < 0.1% |
| Other values (98655) | 112491 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
order_status
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.1 MiB |
| delivered | |
|---|---|
| shipped | 1185 |
| canceled | 542 |
| invoiced | 359 |
| processing | 357 |
| Other values (2) | 10 |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 8.974229229 |
| Min length | 7 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | delivered |
|---|---|
| 2nd row | delivered |
| 3rd row | delivered |
| 4th row | delivered |
| 5th row | delivered |
Common Values
| Value | Count | Frequency (%) |
| delivered | 110194 | |
| shipped | 1185 | 1.1% |
| canceled | 542 | 0.5% |
| invoiced | 359 | 0.3% |
| processing | 357 | 0.3% |
| unavailable | 7 | < 0.1% |
| approved | 3 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| delivered | 110194 | |
| shipped | 1185 | 1.1% |
| canceled | 542 | 0.5% |
| invoiced | 359 | 0.3% |
| processing | 357 | 0.3% |
| unavailable | 7 | < 0.1% |
| approved | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
order_date
Date
| Distinct | 98111 |
|---|---|
| Distinct (%) | 87.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 880.2 KiB |
| Minimum | 2016-09-04 21:15:19 |
|---|---|
| Maximum | 2018-09-03 09:06:57 |
| Distinct | 96049 |
|---|---|
| Distinct (%) | 85.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.2 MiB |
| 2017-07-31 18:03:02 | 21 |
|---|---|
| 2018-08-13 00:00:00 | 20 |
| 2017-12-01 00:00:00 | 20 |
| 2018-03-05 15:22:27 | 20 |
| 2017-09-02 12:13:03 | 20 |
| Other values (96044) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 85406 ? |
|---|---|
| Unique (%) | 75.8% |
Sample
| 1st row | 2017-09-20 23:43:48 |
|---|---|
| 2nd row | 2017-05-12 16:04:24 |
| 3rd row | 2018-01-22 13:19:16 |
| 4th row | 2018-08-14 13:32:39 |
| 5th row | 2017-03-01 16:42:31 |
Common Values
| Value | Count | Frequency (%) |
| 2017-07-31 18:03:02 | 21 | < 0.1% |
| 2018-08-13 00:00:00 | 20 | < 0.1% |
| 2017-12-01 00:00:00 | 20 | < 0.1% |
| 2018-03-05 15:22:27 | 20 | < 0.1% |
| 2017-09-02 12:13:03 | 20 | < 0.1% |
| 2018-08-10 00:00:00 | 18 | < 0.1% |
| 2018-04-12 00:00:00 | 17 | < 0.1% |
| 2018-03-13 00:00:00 | 17 | < 0.1% |
| 2017-12-05 00:00:00 | 17 | < 0.1% |
| 2018-02-06 00:00:00 | 17 | < 0.1% |
| Other values (96039) | 112460 |
Length
| Value | Count | Frequency (%) |
| 00:00:00 | 2454 | 1.1% |
| 2018-05-14 | 524 | 0.2% |
| 2018-08-13 | 521 | 0.2% |
| 2018-05-21 | 508 | 0.2% |
| 2018-08-27 | 501 | 0.2% |
| 2018-05-18 | 494 | 0.2% |
| 2018-04-11 | 482 | 0.2% |
| 2017-12-11 | 480 | 0.2% |
| 2018-05-03 | 476 | 0.2% |
| 2017-06-19 | 473 | 0.2% |
| Other values (41745) | 218381 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 449 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.2 MiB |
| 2017-12-20 00:00:00 | 604 |
|---|---|
| 2018-05-29 00:00:00 | 598 |
| 2018-03-12 00:00:00 | 592 |
| 2018-03-13 00:00:00 | 584 |
| 2018-07-05 00:00:00 | 571 |
| Other values (444) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 18 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2017-09-29 00:00:00 |
|---|---|
| 2nd row | 2017-05-15 00:00:00 |
| 3rd row | 2018-02-05 00:00:00 |
| 4th row | 2018-08-20 00:00:00 |
| 5th row | 2017-03-17 00:00:00 |
Common Values
| Value | Count | Frequency (%) |
| 2017-12-20 00:00:00 | 604 | 0.5% |
| 2018-05-29 00:00:00 | 598 | 0.5% |
| 2018-03-12 00:00:00 | 592 | 0.5% |
| 2018-03-13 00:00:00 | 584 | 0.5% |
| 2018-07-05 00:00:00 | 571 | 0.5% |
| 2018-05-28 00:00:00 | 563 | 0.5% |
| 2017-12-19 00:00:00 | 563 | 0.5% |
| 2018-02-14 00:00:00 | 562 | 0.5% |
| 2017-12-18 00:00:00 | 562 | 0.5% |
| 2018-05-30 00:00:00 | 559 | 0.5% |
| Other values (439) | 106889 |
Length
| Value | Count | Frequency (%) |
| 00:00:00 | 112647 | |
| 2017-12-20 | 604 | 0.3% |
| 2018-05-29 | 598 | 0.3% |
| 2018-03-12 | 592 | 0.3% |
| 2018-03-13 | 584 | 0.3% |
| 2018-07-05 | 571 | 0.3% |
| 2018-05-28 | 563 | 0.2% |
| 2017-12-19 | 563 | 0.2% |
| 2018-02-14 | 562 | 0.2% |
| 2017-12-18 | 562 | 0.2% |
| Other values (440) | 107448 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
review_score
Real number (ℝ≥0)
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.016149269 |
| Minimum | 1 |
|---|---|
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 880.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3.5 |
| median | 5 |
| Q3 | 5 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range (IQR) | 1.5 |
Descriptive statistics
| Standard deviation | 1.398448033 |
|---|---|
| Coefficient of variation (CV) | 0.3482061895 |
| Kurtosis | 0.1239715653 |
| Mean | 4.016149269 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -1.246036083 |
| Sum | 452407.1667 |
| Variance | 1.955656902 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 63180 | |
| 4 | 21229 | 18.8% |
| 1 | 14626 | 13.0% |
| 3 | 9502 | 8.4% |
| 2 | 3941 | 3.5% |
| 4.5 | 69 | 0.1% |
| 2.5 | 48 | < 0.1% |
| 3.5 | 32 | < 0.1% |
| 1.5 | 18 | < 0.1% |
| 3.333333333 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 14626 | |
| 1.5 | 18 | < 0.1% |
| 2 | 3941 | 3.5% |
| 2.5 | 48 | < 0.1% |
| 3 | 9502 | |
| 3.333333333 | 1 | < 0.1% |
| 3.5 | 32 | < 0.1% |
| 4 | 21229 | |
| 4.333333333 | 1 | < 0.1% |
| 4.5 | 69 | 0.1% |
| Value | Count | Frequency (%) |
| 5 | 63180 | |
| 4.5 | 69 | 0.1% |
| 4.333333333 | 1 | < 0.1% |
| 4 | 21229 | 18.8% |
| 3.5 | 32 | < 0.1% |
| 3.333333333 | 1 | < 0.1% |
| 3 | 9502 | 8.4% |
| 2.5 | 48 | < 0.1% |
| 2 | 3941 | 3.5% |
| 1.5 | 18 | < 0.1% |
total_payment
Real number (ℝ≥0)
| Distinct | 28281 |
|---|---|
| Distinct (%) | 25.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 414.6471918 |
| Minimum | 22.05 |
|---|---|
| Maximum | 31427.38 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 880.2 KiB |
Quantile statistics
| Minimum | 22.05 |
|---|---|
| 5-th percentile | 76.986 |
| Q1 | 151.04 |
| median | 263.21 |
| Q3 | 449.4 |
| 95-th percentile | 1222.4 |
| Maximum | 31427.38 |
| Range | 31405.33 |
| Interquartile range (IQR) | 298.36 |
Descriptive statistics
| Standard deviation | 627.5527635 |
|---|---|
| Coefficient of variation (CV) | 1.513461989 |
| Kurtosis | 489.284683 |
| Mean | 414.6471918 |
| Median Absolute Deviation (MAD) | 131.01 |
| Skewness | 13.87773494 |
| Sum | 46708762.21 |
| Variance | 393822.471 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 178.41 | 255 | 0.2% |
| 80.5 | 166 | 0.1% |
| 168.68 | 161 | 0.1% |
| 268.96 | 131 | 0.1% |
| 130.59 | 123 | 0.1% |
| 149.5 | 117 | 0.1% |
| 247.89 | 117 | 0.1% |
| 356.82 | 117 | 0.1% |
| 229.77 | 106 | 0.1% |
| 155.25 | 106 | 0.1% |
| Other values (28271) | 111248 |
| Value | Count | Frequency (%) |
| 22.05 | 1 | |
| 23.16 | 1 | |
| 25.05 | 1 | |
| 26.59 | 1 | |
| 26.73 | 1 | |
| 26.75 | 2 | |
| 28.11 | 1 | |
| 28.24 | 1 | |
| 28.5 | 1 | |
| 29.65 | 2 |
| Value | Count | Frequency (%) |
| 31427.38 | 8 | |
| 16732.22 | 4 | |
| 15937.41 | 1 | < 0.1% |
| 15921.08 | 1 | < 0.1% |
| 15471.32 | 1 | < 0.1% |
| 13987.54 | 6 | |
| 11385.78 | 1 | < 0.1% |
| 11061.71 | 2 | < 0.1% |
| 10957.98 | 1 | < 0.1% |
| 10768.09 | 1 | < 0.1% |
| Distinct | 74 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.2 MiB |
| credit_card | |
|---|---|
| boleto | |
| debit_card | 1688 |
| voucher | 1192 |
| credit_card,voucher | 1112 |
| Other values (69) | 2172 |
Length
| Max length | 231 |
|---|---|
| Median length | 11 |
| Mean length | 10.27495628 |
| Min length | 6 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 24 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | credit_card |
|---|---|
| 2nd row | credit_card |
| 3rd row | credit_card |
| 4th row | credit_card |
| 5th row | credit_card |
Common Values
| Value | Count | Frequency (%) |
| credit_card | 83616 | |
| boleto | 22867 | 20.3% |
| debit_card | 1688 | 1.5% |
| voucher | 1192 | 1.1% |
| credit_card,voucher | 1112 | 1.0% |
| voucher,credit_card | 954 | 0.8% |
| credit_card,credit_card | 331 | 0.3% |
| voucher,voucher | 243 | 0.2% |
| voucher,voucher,credit_card | 100 | 0.1% |
| voucher,voucher,voucher | 95 | 0.1% |
| Other values (64) | 449 | 0.4% |
Length
| Value | Count | Frequency (%) |
| credit_card | 83616 | |
| boleto | 22867 | 20.3% |
| debit_card | 1688 | 1.5% |
| voucher | 1192 | 1.1% |
| credit_card,voucher | 1112 | 1.0% |
| voucher,credit_card | 954 | 0.8% |
| credit_card,credit_card | 331 | 0.3% |
| voucher,voucher | 243 | 0.2% |
| voucher,voucher,credit_card | 100 | 0.1% |
| voucher,voucher,voucher | 95 | 0.1% |
| Other values (64) | 449 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 95419 |
|---|---|
| Distinct (%) | 84.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.6 MiB |
| c8460e4251689ba205045f3ea17884a1 | 24 |
|---|---|
| 4546caea018ad8c692964e3382debd19 | 21 |
| 698e1cf81d01a3d389d96145f7fa6df8 | 20 |
| c402f431464c72e27330a67f7b94d4fb | 20 |
| 0f5ac8d5c31de21d2f25e24be15bbffb | 18 |
| Other values (95414) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 83551 ? |
|---|---|
| Unique (%) | 74.2% |
Sample
| 1st row | 871766c5855e863f6eccc05f988b23cb |
|---|---|
| 2nd row | eb28e67c4c0b83846050ddfb8a35d051 |
| 3rd row | 3818d81c6709e39d06b2738a8d3a2474 |
| 4th row | af861d436cfc08b2c2ddefd0ba074622 |
| 5th row | 64b576fb70d441e8f1b2d7d446e483c5 |
Common Values
| Value | Count | Frequency (%) |
| c8460e4251689ba205045f3ea17884a1 | 24 | < 0.1% |
| 4546caea018ad8c692964e3382debd19 | 21 | < 0.1% |
| 698e1cf81d01a3d389d96145f7fa6df8 | 20 | < 0.1% |
| c402f431464c72e27330a67f7b94d4fb | 20 | < 0.1% |
| 0f5ac8d5c31de21d2f25e24be15bbffb | 18 | < 0.1% |
| 8d50f5eadf50201ccdcedfb9e2ac8455 | 16 | < 0.1% |
| eae0a83d752b1dd32697e0e7b4221656 | 15 | < 0.1% |
| 11f97da02237a49c8e783dfda6f50e8e | 15 | < 0.1% |
| 31e412b9fb766b6794724ed17a41dfa6 | 14 | < 0.1% |
| f7ea4eef770a388bd5b225acfc546604 | 14 | < 0.1% |
| Other values (95409) | 112470 |
Length
| Value | Count | Frequency (%) |
| c8460e4251689ba205045f3ea17884a1 | 24 | < 0.1% |
| 4546caea018ad8c692964e3382debd19 | 21 | < 0.1% |
| 698e1cf81d01a3d389d96145f7fa6df8 | 20 | < 0.1% |
| c402f431464c72e27330a67f7b94d4fb | 20 | < 0.1% |
| 0f5ac8d5c31de21d2f25e24be15bbffb | 18 | < 0.1% |
| 8d50f5eadf50201ccdcedfb9e2ac8455 | 16 | < 0.1% |
| eae0a83d752b1dd32697e0e7b4221656 | 15 | < 0.1% |
| 11f97da02237a49c8e783dfda6f50e8e | 15 | < 0.1% |
| 3e43e6105506432c953e165fb2acf44c | 14 | < 0.1% |
| 31e412b9fb766b6794724ed17a41dfa6 | 14 | < 0.1% |
| Other values (95409) | 112470 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 14976 |
|---|---|
| Distinct (%) | 13.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35119.85556 |
| Minimum | 1003 |
|---|---|
| Maximum | 99990 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 880.2 KiB |
Quantile statistics
| Minimum | 1003 |
|---|---|
| 5-th percentile | 3308 |
| Q1 | 11310 |
| median | 24340 |
| Q3 | 59030 |
| 95-th percentile | 90598 |
| Maximum | 99990 |
| Range | 98987 |
| Interquartile range (IQR) | 47720 |
Descriptive statistics
| Standard deviation | 29866.33077 |
|---|---|
| Coefficient of variation (CV) | 0.8504115491 |
| Kurtosis | -0.7928674712 |
| Mean | 35119.85556 |
| Median Absolute Deviation (MAD) | 16389 |
| Skewness | 0.7801231393 |
| Sum | 3956146369 |
| Variance | 891997713.6 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 22790 | 154 | 0.1% |
| 22793 | 151 | 0.1% |
| 24220 | 145 | 0.1% |
| 24230 | 134 | 0.1% |
| 22775 | 123 | 0.1% |
| 29101 | 113 | 0.1% |
| 35162 | 111 | 0.1% |
| 11740 | 106 | 0.1% |
| 13212 | 104 | 0.1% |
| 22631 | 104 | 0.1% |
| Other values (14966) | 111402 |
| Value | Count | Frequency (%) |
| 1003 | 1 | < 0.1% |
| 1004 | 2 | < 0.1% |
| 1005 | 6 | |
| 1006 | 2 | < 0.1% |
| 1007 | 4 | |
| 1008 | 4 | |
| 1009 | 8 | |
| 1011 | 6 | |
| 1012 | 2 | < 0.1% |
| 1013 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 99990 | 1 | < 0.1% |
| 99980 | 3 | < 0.1% |
| 99970 | 1 | < 0.1% |
| 99965 | 2 | < 0.1% |
| 99960 | 1 | < 0.1% |
| 99955 | 3 | < 0.1% |
| 99950 | 9 | |
| 99940 | 2 | < 0.1% |
| 99930 | 5 | |
| 99925 | 1 | < 0.1% |
| Distinct | 4110 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.2 MiB |
| sao paulo | |
|---|---|
| rio de janeiro | 7837 |
| belo horizonte | 3144 |
| brasilia | 2392 |
| curitiba | 1751 |
| Other values (4105) |
Length
| Max length | 32 |
|---|---|
| Median length | 9 |
| Mean length | 10.33830462 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1057 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | campos dos goytacazes |
|---|---|
| 2nd row | santa fe do sul |
| 3rd row | para de minas |
| 4th row | atibaia |
| 5th row | varzea paulista |
Common Values
| Value | Count | Frequency (%) |
| sao paulo | 17808 | 15.8% |
| rio de janeiro | 7837 | 7.0% |
| belo horizonte | 3144 | 2.8% |
| brasilia | 2392 | 2.1% |
| curitiba | 1751 | 1.6% |
| campinas | 1654 | 1.5% |
| porto alegre | 1612 | 1.4% |
| salvador | 1412 | 1.3% |
| guarulhos | 1329 | 1.2% |
| sao bernardo do campo | 1060 | 0.9% |
| Other values (4100) | 72648 |
Length
| Value | Count | Frequency (%) |
| sao | 23985 | 12.1% |
| paulo | 17887 | 9.1% |
| de | 10972 | 5.6% |
| rio | 9436 | 4.8% |
| janeiro | 7837 | 4.0% |
| do | 4868 | 2.5% |
| belo | 3214 | 1.6% |
| horizonte | 3172 | 1.6% |
| brasilia | 2402 | 1.2% |
| porto | 1915 | 1.0% |
| Other values (3280) | 111800 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.3 MiB |
| SP | |
|---|---|
| RJ | |
| MG | |
| RS | |
| PR | |
| Other values (22) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | RJ |
|---|---|
| 2nd row | SP |
| 3rd row | MG |
| 4th row | SP |
| 5th row | SP |
Common Values
| Value | Count | Frequency (%) |
| SP | 47446 | |
| RJ | 14579 | 12.9% |
| MG | 13129 | 11.7% |
| RS | 6235 | 5.5% |
| PR | 5740 | 5.1% |
| SC | 4176 | 3.7% |
| BA | 3799 | 3.4% |
| DF | 2406 | 2.1% |
| GO | 2333 | 2.1% |
| ES | 2256 | 2.0% |
| Other values (17) | 10548 | 9.4% |
Length
| Value | Count | Frequency (%) |
| sp | 47446 | |
| rj | 14579 | 12.9% |
| mg | 13129 | 11.7% |
| rs | 6235 | 5.5% |
| pr | 5740 | 5.1% |
| sc | 4176 | 3.7% |
| ba | 3799 | 3.4% |
| df | 2406 | 2.1% |
| go | 2333 | 2.1% |
| es | 2256 | 2.0% |
| Other values (17) | 10548 | 9.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
customer_age
Real number (ℝ≥0)
| Distinct | 72 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 49.5508358 |
| Minimum | 14 |
|---|---|
| Maximum | 85 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 880.2 KiB |
Quantile statistics
| Minimum | 14 |
|---|---|
| 5-th percentile | 17 |
| Q1 | 32 |
| median | 50 |
| Q3 | 68 |
| 95-th percentile | 82 |
| Maximum | 85 |
| Range | 71 |
| Interquartile range (IQR) | 36 |
Descriptive statistics
| Standard deviation | 20.81476474 |
|---|---|
| Coefficient of variation (CV) | 0.4200688929 |
| Kurtosis | -1.201018794 |
| Mean | 49.5508358 |
| Median Absolute Deviation (MAD) | 18 |
| Skewness | -0.001716514946 |
| Sum | 5581753 |
| Variance | 433.254431 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 32 | 1659 | 1.5% |
| 14 | 1654 | 1.5% |
| 50 | 1643 | 1.5% |
| 29 | 1634 | 1.5% |
| 83 | 1634 | 1.5% |
| 71 | 1625 | 1.4% |
| 55 | 1620 | 1.4% |
| 57 | 1615 | 1.4% |
| 67 | 1613 | 1.4% |
| 36 | 1613 | 1.4% |
| Other values (62) | 96337 |
| Value | Count | Frequency (%) |
| 14 | 1654 | |
| 15 | 1575 | |
| 16 | 1544 | |
| 17 | 1565 | |
| 18 | 1531 | |
| 19 | 1556 | |
| 20 | 1553 | |
| 21 | 1503 | |
| 22 | 1592 | |
| 23 | 1570 |
| Value | Count | Frequency (%) |
| 85 | 1597 | |
| 84 | 1587 | |
| 83 | 1634 | |
| 82 | 1611 | |
| 81 | 1574 | |
| 80 | 1559 | |
| 79 | 1563 | |
| 78 | 1502 | |
| 77 | 1592 | |
| 76 | 1577 |
customer_income
Real number (ℝ≥0)
| Distinct | 35159 |
|---|---|
| Distinct (%) | 31.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20924.35273 |
| Minimum | 2000 |
|---|---|
| Maximum | 40000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 880.2 KiB |
Quantile statistics
| Minimum | 2000 |
|---|---|
| 5-th percentile | 3860 |
| Q1 | 11476 |
| median | 20867 |
| Q3 | 30441.5 |
| 95-th percentile | 38055.7 |
| Maximum | 40000 |
| Range | 38000 |
| Interquartile range (IQR) | 18965.5 |
Descriptive statistics
| Standard deviation | 10959.11792 |
|---|---|
| Coefficient of variation (CV) | 0.5237494352 |
| Kurtosis | -1.198209257 |
| Mean | 20924.35273 |
| Median Absolute Deviation (MAD) | 9474 |
| Skewness | 0.006106550577 |
| Sum | 2357065562 |
| Variance | 120102265.7 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7703 | 21 | < 0.1% |
| 23733 | 21 | < 0.1% |
| 11516 | 20 | < 0.1% |
| 2014 | 18 | < 0.1% |
| 5610 | 18 | < 0.1% |
| 17115 | 18 | < 0.1% |
| 15098 | 17 | < 0.1% |
| 24651 | 16 | < 0.1% |
| 39268 | 16 | < 0.1% |
| 27619 | 16 | < 0.1% |
| Other values (35149) | 112466 |
| Value | Count | Frequency (%) |
| 2000 | 2 | < 0.1% |
| 2001 | 1 | < 0.1% |
| 2002 | 3 | < 0.1% |
| 2003 | 3 | < 0.1% |
| 2004 | 3 | < 0.1% |
| 2006 | 2 | < 0.1% |
| 2007 | 1 | < 0.1% |
| 2008 | 2 | < 0.1% |
| 2009 | 8 | |
| 2010 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 40000 | 5 | |
| 39999 | 2 | < 0.1% |
| 39998 | 1 | < 0.1% |
| 39997 | 4 | |
| 39996 | 7 | |
| 39995 | 1 | < 0.1% |
| 39994 | 6 | |
| 39992 | 1 | < 0.1% |
| 39991 | 2 | < 0.1% |
| 39990 | 3 |
customer_marital_status
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.2 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 56395 | |
| 1 | 56252 |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 56395 | |
| 1 | 56252 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.6 MiB |
| 2018 | |
|---|---|
| 2017 | |
| 2016 | 367 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2017 |
|---|---|
| 2nd row | 2017 |
| 3rd row | 2018 |
| 4th row | 2018 |
| 5th row | 2017 |
Common Values
| Value | Count | Frequency (%) |
| 2018 | 61416 | |
| 2017 | 50864 | |
| 2016 | 367 | 0.3% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 2018 | 61416 | |
| 2017 | 50864 | |
| 2016 | 367 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.02675615 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 880.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 8 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.232548014 |
|---|---|
| Coefficient of variation (CV) | 0.5363661534 |
| Kurtosis | -0.9806750194 |
| Mean | 6.02675615 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.2084695862 |
| Sum | 678896 |
| Variance | 10.44936666 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8 | 12158 | |
| 5 | 12061 | |
| 7 | 11611 | |
| 3 | 11217 | |
| 6 | 10661 | |
| 4 | 10659 | |
| 2 | 9623 | |
| 1 | 9163 | |
| 11 | 8665 | |
| 12 | 6309 | |
| Other values (2) | 10520 |
| Value | Count | Frequency (%) |
| 1 | 9163 | |
| 2 | 9623 | |
| 3 | 11217 | |
| 4 | 10659 | |
| 5 | 12061 | |
| 6 | 10661 | |
| 7 | 11611 | |
| 8 | 12158 | |
| 9 | 4835 | 4.3% |
| 10 | 5685 |
| Value | Count | Frequency (%) |
| 12 | 6309 | |
| 11 | 8665 | |
| 10 | 5685 | |
| 9 | 4835 | 4.3% |
| 8 | 12158 | |
| 7 | 11611 | |
| 6 | 10661 | |
| 5 | 12061 | |
| 4 | 10659 | |
| 3 | 11217 |
order_weekday
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.9 MiB |
| Monday | |
|---|---|
| Tuesday | |
| Wednesday | |
| Thursday | |
| Friday | |
| Other values (2) |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 7.144824097 |
| Min length | 6 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Wednesday |
|---|---|
| 2nd row | Wednesday |
| 3rd row | Sunday |
| 4th row | Wednesday |
| 5th row | Saturday |
Common Values
| Value | Count | Frequency (%) |
| Monday | 18393 | |
| Tuesday | 18237 | |
| Wednesday | 17600 | |
| Thursday | 16794 | |
| Friday | 16039 | |
| Sunday | 13416 | |
| Saturday | 12168 |
Length
Pie chart
| Value | Count | Frequency (%) |
| monday | 18393 | |
| tuesday | 18237 | |
| wednesday | 17600 | |
| thursday | 16794 | |
| friday | 16039 | |
| sunday | 13416 | |
| saturday | 12168 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| df_index | order_id | order_item_id | product_id | seller_id | seller_zip_code | seller_city | seller_state | product_category_name_english | customer_id | order_status | order_date | order_delivery_date | order_estimated_delivery_date | review_score | total_payment | payment_type | customer_unique_id | customer_zip_code | customer_city | customer_state | customer_age | customer_income | customer_marital_status | order_year | order_month | order_weekday | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 00010242fe8c5a6d1ba2dd792cb16214 | 1 | 4244733e06e7ecb4970a6e2683c13e61 | 48436dade18ac8b2bce089ec2a041202 | 27277 | volta redonda | SP | cool_stuff | 3ce436f183e68e07877b285a838db11a | delivered | 2017-09-13 08:59:02 | 2017-09-20 23:43:48 | 2017-09-29 00:00:00 | 5.0 | 166.04 | credit_card | 871766c5855e863f6eccc05f988b23cb | 28013 | campos dos goytacazes | RJ | 77 | 7208 | 0 | 2017 | 9 | Wednesday |
| 1 | 1 | 00018f77f2f0320c557190d7a144bdd3 | 1 | e5f2d52b802189ee658865ca93d83a8f | dd7ddc04e1b6c2c614352b383efe2d36 | 3471 | sao paulo | SP | pet_shop | f6dd3ec061db4e3987629fe6b26e5cce | delivered | 2017-04-26 10:53:06 | 2017-05-12 16:04:24 | 2017-05-15 00:00:00 | 4.0 | 597.61 | credit_card | eb28e67c4c0b83846050ddfb8a35d051 | 15775 | santa fe do sul | SP | 15 | 6142 | 1 | 2017 | 4 | Wednesday |
| 2 | 2 | 000229ec398224ef6ca0657da4fc703e | 1 | c777355d18b72b67abbeef9df44fd0fd | 5b51032eddd242adc84c38acab88f23d | 37564 | borda da mata | MG | furniture_decor | 6489ae5e4333f3693df5ad4372dab6d3 | delivered | 2018-01-14 14:33:31 | 2018-01-22 13:19:16 | 2018-02-05 00:00:00 | 5.0 | 498.80 | credit_card | 3818d81c6709e39d06b2738a8d3a2474 | 35661 | para de minas | MG | 64 | 24244 | 1 | 2018 | 1 | Sunday |
| 3 | 3 | 00024acbcdf0a6daa1e931b038114c75 | 1 | 7634da152a4610f1595efa32f14722fc | 9d7a1d34a5052409006425275ba1c2b4 | 14403 | franca | SP | perfumery | d4eb9395c8c0431ee92fce09860c5a06 | delivered | 2018-08-08 10:00:35 | 2018-08-14 13:32:39 | 2018-08-20 00:00:00 | 4.0 | 59.29 | credit_card | af861d436cfc08b2c2ddefd0ba074622 | 12952 | atibaia | SP | 56 | 23541 | 0 | 2018 | 8 | Wednesday |
| 4 | 4 | 00042b26cf59d7ce69dfabb4e55b4fd9 | 1 | ac6c3623068f30de03045865e4e10089 | df560393f3a51e74553ab94004ba5c87 | 87900 | loanda | PR | garden_tools | 58dbd0b2d70206bf40e62cd34e84d795 | delivered | 2017-02-04 13:57:51 | 2017-03-01 16:42:31 | 2017-03-17 00:00:00 | 5.0 | 501.49 | credit_card | 64b576fb70d441e8f1b2d7d446e483c5 | 13226 | varzea paulista | SP | 59 | 29817 | 0 | 2017 | 2 | Saturday |
| 5 | 5 | 00048cc3ae777c65dbb7d2a0634bc1ea | 1 | ef92defde845ab8450f9d70c526ef70f | 6426d21aca402a131fc0a5d0960a3c90 | 14091 | ribeirao preto | SP | housewares | 816cbea969fe5b689b39cfc97a506742 | delivered | 2017-05-15 21:42:34 | 2017-05-22 13:44:35 | 2017-06-06 00:00:00 | 4.0 | 79.56 | boleto | 85c835d128beae5b4ce8602c491bf385 | 38017 | uberaba | MG | 14 | 37081 | 0 | 2017 | 5 | Monday |
| 6 | 6 | 00054e8431b9d7675808bcb819fb4a32 | 1 | 8d4f2bb7e93e6710a28f34fa83ee7d28 | 7040e82f899a04d1b434b795a43b4617 | 1026 | sao paulo | SP | telephony | 32e2e6ab09e778d99bf2e0ecd4898718 | delivered | 2017-12-10 11:53:48 | 2017-12-18 22:03:38 | 2018-01-04 00:00:00 | 4.0 | 73.03 | credit_card | 635d9ac1680f03288e72ada3a1035803 | 16700 | guararapes | SP | 39 | 25237 | 0 | 2017 | 12 | Sunday |
| 7 | 7 | 000576fe39319847cbb9d288c5617fa6 | 1 | 557d850972a7d6f792fd18ae1400d9b6 | 5996cddab893a4652a15592fb58ab8db | 19010 | presidente prudente | SP | garden_tools | 9ed5e522dd9dd85b4af4a077526d8117 | delivered | 2018-07-04 12:08:27 | 2018-07-09 14:04:07 | 2018-07-25 00:00:00 | 5.0 | 2025.73 | credit_card | fda4476abb6307ab3c415b7e6d026526 | 11702 | praia grande | SP | 64 | 29705 | 0 | 2018 | 7 | Wednesday |
| 8 | 8 | 0005a1a1728c9d785b8e2b08b904576c | 1 | 310ae3c140ff94b03219ad0adc3c778f | a416b6a846a11724393025641d4edd5e | 3702 | sao paulo | SP | health_beauty | 16150771dfd4776261284213b89c304e | delivered | 2018-03-19 18:40:33 | 2018-03-29 18:17:31 | 2018-03-29 00:00:00 | 1.0 | 362.48 | credit_card | 639d23421f5517f69d0c3d6e6564cf0e | 11075 | santos | SP | 22 | 29901 | 0 | 2018 | 3 | Monday |
| 9 | 9 | 0005f50442cb953dcd1d21e1fb923495 | 1 | 4535b0e1091c278dfd193e5a1d63b39f | ba143b05f0110f0dc71ad71b4466ce92 | 2274 | sao paulo | SP | books_technical | 351d3cb2cee3c7fd0af6616c82df21d3 | delivered | 2018-07-02 13:59:39 | 2018-07-04 17:28:31 | 2018-07-23 00:00:00 | 4.0 | 150.40 | credit_card | 0782c41380992a5a533489063df0eef6 | 6636 | jandira | SP | 80 | 32094 | 0 | 2018 | 7 | Monday |
Last rows
| df_index | order_id | order_item_id | product_id | seller_id | seller_zip_code | seller_city | seller_state | product_category_name_english | customer_id | order_status | order_date | order_delivery_date | order_estimated_delivery_date | review_score | total_payment | payment_type | customer_unique_id | customer_zip_code | customer_city | customer_state | customer_age | customer_income | customer_marital_status | order_year | order_month | order_weekday | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 112637 | 112640 | fffb9224b6fc7c43ebb0904318b10b5f | 1 | 43423cdffde7fda63d0414ed38c11a73 | b1fc4f64df5a0e8b6913ab38803c57a9 | 24440 | sao goncalo | RJ | watches_gifts | 4d3abb73ceb86353aeadbe698aa9d5cb | delivered | 2017-10-27 16:51:00 | 2017-11-17 19:41:42 | 2017-11-27 00:00:00 | 4.0 | 820.55 | boleto | f736308cd9952b33b90b9fe94da9c8f5 | 56912 | serra talhada | PE | 14 | 7942 | 1 | 2017 | 10 | Friday |
| 112638 | 112641 | fffb9224b6fc7c43ebb0904318b10b5f | 2 | 43423cdffde7fda63d0414ed38c11a73 | b1fc4f64df5a0e8b6913ab38803c57a9 | 24440 | sao goncalo | RJ | watches_gifts | 4d3abb73ceb86353aeadbe698aa9d5cb | delivered | 2017-10-27 16:51:00 | 2017-11-17 19:41:42 | 2017-11-27 00:00:00 | 4.0 | 820.55 | boleto | f736308cd9952b33b90b9fe94da9c8f5 | 56912 | serra talhada | PE | 14 | 7942 | 1 | 2017 | 10 | Friday |
| 112639 | 112642 | fffb9224b6fc7c43ebb0904318b10b5f | 3 | 43423cdffde7fda63d0414ed38c11a73 | b1fc4f64df5a0e8b6913ab38803c57a9 | 24440 | sao goncalo | RJ | watches_gifts | 4d3abb73ceb86353aeadbe698aa9d5cb | delivered | 2017-10-27 16:51:00 | 2017-11-17 19:41:42 | 2017-11-27 00:00:00 | 4.0 | 820.55 | boleto | f736308cd9952b33b90b9fe94da9c8f5 | 56912 | serra talhada | PE | 14 | 7942 | 1 | 2017 | 10 | Friday |
| 112640 | 112643 | fffb9224b6fc7c43ebb0904318b10b5f | 4 | 43423cdffde7fda63d0414ed38c11a73 | b1fc4f64df5a0e8b6913ab38803c57a9 | 24440 | sao goncalo | RJ | watches_gifts | 4d3abb73ceb86353aeadbe698aa9d5cb | delivered | 2017-10-27 16:51:00 | 2017-11-17 19:41:42 | 2017-11-27 00:00:00 | 4.0 | 820.55 | boleto | f736308cd9952b33b90b9fe94da9c8f5 | 56912 | serra talhada | PE | 14 | 7942 | 1 | 2017 | 10 | Friday |
| 112641 | 112644 | fffbee3b5462987e66fb49b1c5411df2 | 1 | 6f0169f259bb0ff432bfff7d829b9946 | 213b25e6f54661939f11710a6fddb871 | 13321 | salto | SP | home_construction | 11a0e041ea6e7e21856d2689b64e7f3a | delivered | 2018-06-19 09:27:48 | 2018-07-05 17:51:08 | 2018-07-23 00:00:00 | 5.0 | 321.72 | credit_card | ecc3d4eb9b17d2f0865d21f2abecc51c | 39401 | montes claros | MG | 21 | 18335 | 1 | 2018 | 6 | Tuesday |
| 112642 | 112645 | fffc94f6ce00a00581880bf54a75a037 | 1 | 4aa6014eceb682077f9dc4bffebc05b0 | b8bc237ba3788b23da09c0f1f3a3288c | 88303 | itajai | SC | housewares | b51593916b4b8e0d6f66f2ae24f2673d | delivered | 2018-04-23 13:57:06 | 2018-05-10 22:56:40 | 2018-05-18 00:00:00 | 5.0 | 789.82 | boleto | 0c9aeda10a71f369396d0c04dce13a64 | 65077 | sao luis | MA | 35 | 22497 | 0 | 2018 | 4 | Monday |
| 112643 | 112646 | fffcd46ef2263f404302a634eb57f7eb | 1 | 32e07fd915822b0765e448c4dd74c828 | f3c38ab652836d21de61fb8314b69182 | 1206 | sao paulo | SP | computers_accessories | 84c5d4fbaf120aae381fad077416eaa0 | delivered | 2018-07-14 10:26:46 | 2018-07-23 20:31:55 | 2018-08-01 00:00:00 | 5.0 | 889.02 | boleto | 0da9fe112eae0c74d3ba1fe16de0988b | 81690 | curitiba | PR | 36 | 27170 | 1 | 2018 | 7 | Saturday |
| 112644 | 112647 | fffce4705a9662cd70adb13d4a31832d | 1 | 72a30483855e2eafc67aee5dc2560482 | c3cfdc648177fdbbbb35635a37472c53 | 80610 | curitiba | PR | sports_leisure | 29309aa813182aaddc9b259e31b870e6 | delivered | 2017-10-23 17:07:56 | 2017-10-28 12:22:22 | 2017-11-10 00:00:00 | 5.0 | 268.76 | credit_card | cd79b407828f02fdbba457111c38e4c4 | 4039 | sao paulo | SP | 61 | 37357 | 1 | 2017 | 10 | Monday |
| 112645 | 112648 | fffe18544ffabc95dfada21779c9644f | 1 | 9c422a519119dcad7575db5af1ba540e | 2b3e4a2a3ea8e01938cabda2a3e5cc79 | 4733 | sao paulo | SP | computers_accessories | b5e6afd5a41800fdf401e0272ca74655 | delivered | 2017-08-14 23:02:59 | 2017-08-16 21:59:40 | 2017-08-25 00:00:00 | 5.0 | 148.83 | credit_card | eb803377c9315b564bdedad672039306 | 13289 | vinhedo | SP | 67 | 3786 | 0 | 2017 | 8 | Monday |
| 112646 | 112649 | fffe41c64501cc87c801fd61db3f6244 | 1 | 350688d9dc1e75ff97be326363655e01 | f7ccf836d21b2fb1de37564105216cc1 | 14940 | ibitinga | SP | bed_bath_table | 96d649da0cc4ff33bb408b199d4c7dcf | delivered | 2018-06-09 17:00:18 | 2018-06-14 17:56:26 | 2018-06-28 00:00:00 | 5.0 | 128.32 | credit_card | cd76a00d8e3ca5e6ab9ed9ecb6667ac4 | 18605 | botucatu | SP | 58 | 39665 | 1 | 2018 | 6 | Saturday |